SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481723 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481723 [ RunTime:0.002244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388323,3711,382398,180555,376847,710607,740972,338676,220524,649441,1003399,119766,702549,285626,175789,745785,438434,582379,526980,292019,711573,480789,943001,1008038,254913,672914,302447,9614,727396,875682,552916,71587,230594,743065,858078,944109,490950,271887,322023,819091,749930,603641,553272,127534,594708,327880,915638,185595,968931,412822,814723,496181,898464,356181,699343,1172,844454,687165,499963,563348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]