SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471050 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471050 [ RunTime:0.002800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853771,1003112,617572,750522,818444,331210,458521,987482,15580,754539,601034,535115,948046,341989,655272,1040376,184315,365175,531910,532532,755499,642788,86918,405854,714128,428085,392503,383561,599004,879174,838476,552239,684316,15245,562835,137738,136039,801719,339966,77613,823251,233448,214898,331240,198780,54391,765070,211209,466697,501010,379497,75709,951213,65300,899964,890338,951450,179656,367655,232179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]