SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 177612 LIMIT 1 [ RunTime:0.001484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 177612 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468843,1025841,760041,787708,425902,220702,786659,384143,281076,26342,1010699,741621,679434,197624,1046369,8968,390241,220350,239958,527816,721915,426,195332,871180,266770,722650,643124,327556,73950,71541,591225,276688,101352,350950,126237,94787,440606,102488,639591,1039223,339481,683537,243561,785635,462180,178041,130362,242046,655320,859609,187463,667049,406331,171783,499633,264848,425118,729697,395375,364669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 177612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 177612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]