SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803644 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803644 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825986,615936,402334,913112,411299,162554,117330,210613,986881,615501,1039898,372763,238469,349542,59941,251334,801808,948398,556859,898533,566408,318678,26090,455490,838867,1024958,347034,140456,351637,69409,88211,97250,197389,452993,746490,76850,120816,642414,452165,980661,953099,198358,615255,674861,13349,201133,486306,979665,500140,963287,647477,862124,617514,125643,439483,688427,604047,270255,698428,251188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]