SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407180 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407180 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672822,142481,623080,352483,718868,317140,336709,906219,649577,924238,332503,456568,432345,624658,1000566,849712,98470,562642,236008,73266,551248,606458,1011228,236281,732662,766073,95157,741183,587628,705624,228134,1046442,551660,221362,635168,335181,417966,880498,915448,686740,966113,960961,522669,829404,148137,519305,460394,522134,60874,390635,435848,648271,750109,51581,319582,784033,102305,850505,552137,147052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]