SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001585s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105630 LIMIT 1 [ RunTime:0.001254s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105630 [ RunTime:0.002711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997117,980515,1002498,912927,469659,797710,427333,518277,984600,927636,58912,766734,663300,921518,740270,31667,111884,984430,9445,396169,678163,505954,935977,994628,458036,946966,222500,97519,248664,232247,114650,140955,480143,200491,563478,445265,841843,1030524,138757,547924,816335,111011,739006,1011287,97706,822586,214677,403236,50813,185542,763918,901698,944000,788944,135875,969554,628471,85345,495128,699586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002671s ]