SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523080 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523080 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912183,579773,887863,1041152,344076,881717,433379,1046345,871255,767747,824286,77072,1037752,433828,135596,308863,413916,320385,646472,62554,825951,784508,376249,318215,596811,90278,88348,608462,126802,763790,760581,774329,483755,1004755,842394,269088,90964,501095,187124,485575,361304,20084,1044149,471348,589767,165915,144586,328415,24065,871334,750013,517490,120134,324716,276819,504095,669417,707348,349263,182146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]