SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538845 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538845 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300841,253853,535218,472596,962545,1003430,418672,215697,1046831,998422,965530,1032169,279156,215864,465323,723698,491064,729661,538475,927723,415970,513552,284114,820273,199798,267756,766501,107485,332695,652923,948398,303512,832562,997838,176975,820517,49652,336727,894255,74671,736985,104660,489465,934720,335993,201938,994383,668554,928346,662831,972946,699834,838375,873099,763482,836820,636757,704329,422687,192362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]