SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 162818 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 162818 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375447,169933,605336,1044744,848613,651150,765570,299368,466878,105112,536413,509343,630679,239192,63296,345639,154719,318774,191722,878009,836302,113593,954570,1004848,182168,300323,978824,999348,830609,414712,679173,738973,860932,434032,900062,328319,763549,1038799,136195,975170,989762,436659,1010047,187454,992759,141250,205754,124791,307182,69106,688081,675824,257181,664191,518742,602668,213526,211609,619695,195673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 162818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 162818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]