SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320820 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320820 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010001,811872,120724,657323,1041734,869258,734696,67403,163664,294386,607908,690605,752055,899185,1012368,401081,988342,850185,634378,563226,1012294,683677,527694,332907,193618,462421,971483,710828,634056,421195,685117,160822,648207,749900,181439,320928,422745,779811,577570,954822,951014,268776,384859,529048,940402,539934,52248,770612,502175,21765,169267,271984,625723,999475,73896,899217,440438,465567,771167,700561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]