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` = 415008 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415008 [ RunTime:0.002045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031534,689316,279450,633397,580139,844875,383640,917318,661953,998149,578607,712569,947282,349008,25550,119152,617588,557211,729396,947484,666174,604460,186485,602999,550752,350667,57976,974639,272187,640931,742028,826584,715270,414035,94772,364600,253306,204658,526995,217158,427776,787120,136914,710859,808713,217692,759954,836316,469970,199205,91478,348119,863016,161131,674039,648151,109185,712070,526445,525472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]