SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445555 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445555 [ RunTime:0.003568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468802,616004,490288,309268,1047320,630699,785231,968925,532734,333768,91640,322860,462326,430651,1039660,407278,206252,714949,553698,938062,101859,923794,244787,181741,859098,835323,368992,79642,614990,65629,791533,651506,867918,431238,972793,683733,330173,627104,727429,193467,903404,208319,925093,150182,247757,740249,259145,423392,202818,620959,716429,77658,944477,813734,322440,96397,72550,937248,176513,11189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445555 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445555 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]