SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 370706 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 370706 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019278,981941,1037862,800762,230167,16113,18412,485073,408713,1002224,551907,976087,767672,623032,385018,410931,29186,194031,735554,963792,913882,976853,611115,1014737,962831,731903,505649,330938,14998,325680,25201,365794,567890,23831,214993,574052,3202,480852,367739,142988,61489,128882,610148,181223,350563,287685,525362,440915,827001,932324,747313,438605,29236,833425,62640,307701,603975,202422,1037716,549743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 370706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 370706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]