SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351292 LIMIT 1 [ RunTime:0.001083s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351292 [ RunTime:0.002494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493151,509443,104832,550427,987090,498354,55622,820853,932986,446110,414453,239011,420364,433806,798697,784984,165411,484128,276062,943242,371658,182748,908371,639105,358420,757930,478528,294950,1029726,331194,610045,609054,862601,807879,738228,646177,799437,180048,822212,282074,263342,89083,683660,500362,694556,797121,253099,197019,218371,466085,249743,894106,971801,350611,888972,254231,173367,197422,121124,746228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]