SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519764 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519764 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035530,588325,818232,458164,119505,315632,27659,671179,97485,4513,285024,443790,696856,950512,1003459,467658,585143,82957,803890,814486,11146,513387,628158,443288,185755,524746,842596,155432,17545,633759,71406,971617,395256,149083,456118,1000040,294408,572969,602896,377423,132701,795713,1018665,839701,884113,861366,278354,658860,432660,55559,227325,500525,78331,346735,1010713,1034821,17942,567586,776324,935536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519764 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519764 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]