SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563457 LIMIT 1 [ RunTime:0.000617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563457 [ RunTime:0.003928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526088,731821,831457,471922,763737,271136,731872,21985,456303,253684,624852,961686,271630,359036,970115,483525,887539,173708,1019062,546048,735673,833914,782246,896090,486289,184636,259710,383652,765483,420274,1032893,432866,946066,59507,46214,444652,851336,222297,220901,959494,487767,649803,865922,485807,633718,846144,781633,500330,972855,1044980,287705,978159,749587,507071,674443,1006411,751318,254909,610096,829742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]