SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195445 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195445 [ RunTime:0.001504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834110,381131,765736,922167,332992,409079,1047508,327883,170641,820117,205465,890874,548745,792706,98522,515862,544970,179826,674315,939355,362874,230128,503742,474521,1004853,925968,725045,569884,664910,843965,814309,171073,466963,9298,477956,945265,939815,32457,670698,274619,238941,255607,324074,78301,494451,940102,826834,380310,840128,262773,455826,474434,618173,892679,1021136,62750,159260,658095,492937,822079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]