SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511005 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511005 [ RunTime:0.002318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132270,292093,884401,728712,421448,440350,580307,261207,626340,465220,409061,229646,546350,106532,430255,839009,950657,40256,238892,294735,234944,568657,242843,890893,667957,418274,841018,775970,1006348,463270,986423,413448,695823,374417,423485,1000593,110699,979814,535459,37738,78189,25844,393466,370235,1041957,826806,871963,1014647,188710,177922,149435,620125,211160,913808,990632,786322,889424,166200,177231,520174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003734s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001324s ]