SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3891 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3891 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560341,504898,767833,938507,622101,354814,758814,108719,57993,345755,324233,127376,39288,484577,994986,413497,816547,164123,8605,164809,529409,345027,931823,887136,897586,771857,18444,214944,958084,690063,998933,942929,866041,742731,308526,780035,401654,408856,526226,595611,510931,563042,213873,4547,530633,670735,931185,91202,870811,83507,618726,95012,520034,455988,25719,1046218,823549,91802,337639,142837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]