SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204290 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204290 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436839,214803,504958,964824,1000366,500301,392,751628,459550,346667,218007,598049,516376,1019029,645374,297520,448285,964589,102724,621617,6571,128781,980426,191076,1019095,658336,1043572,282336,844625,629917,245219,639677,796142,386827,942534,339533,441227,374155,151288,194737,340222,136029,984729,997719,168681,3437,257746,159220,237012,33298,319404,960032,801460,1041303,984956,958117,41591,739444,464888,97436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204290 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204290 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]