SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420093 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420093 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350029,836272,406068,576726,895908,150796,764950,103931,971591,665744,761895,829393,148562,249490,894011,196980,259461,337454,622407,727621,1004886,192642,589416,64026,990735,530246,670264,688874,190893,494634,5641,531770,483651,480585,971673,182463,840246,524151,213326,289050,140597,957690,279747,435521,511947,449129,805991,145345,65571,775843,210160,760660,990170,875159,94886,741407,343288,68885,726195,784906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]