SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508623 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508623 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693683,252187,497649,552370,390270,588689,238103,741053,753300,694794,1022867,1019022,726468,485281,877293,822397,1038943,857528,283758,488696,661025,971123,226221,826041,199566,594479,9622,1034098,324163,970016,398358,638220,26623,732967,855838,801708,93389,580150,775809,175317,808491,125774,158259,680208,981838,561883,404532,559314,747339,84067,35668,917430,721388,365063,954225,217807,294553,167137,850893,270151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000953s ]