SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43512 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43512 [ RunTime:0.005190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927678,269327,357047,15764,358142,765364,532291,1025336,999082,364914,1037160,86809,161798,212191,255454,65103,564197,968289,830397,1008235,280740,500884,199273,84115,1024378,253615,728728,110678,249917,637124,886846,328338,1024573,949013,830681,254963,148922,717164,1031941,887980,286042,297778,1016073,301892,708864,1042658,251674,288294,287518,16919,801619,409502,1006217,316322,1034932,1018336,162076,324445,967532,510133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000698s ]