SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511928 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511928 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804020,156355,690974,482715,305388,587655,396861,940228,385426,746591,392694,993248,130756,921137,732451,475287,819660,628760,841821,584820,1001402,423771,71673,563412,513656,144343,954843,498116,63801,32854,757581,518535,506387,627767,211651,289847,453119,848811,596533,7020,98973,230362,9293,1017285,528428,286463,952485,100238,843237,235110,95121,1046673,363696,161201,685729,404572,44849,598918,884210,649205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]