SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010089 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010089 [ RunTime:0.002199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312697,397817,84191,486056,531251,397234,448745,266821,215033,413930,718745,110680,129841,408835,207037,310492,480947,974138,250641,44791,765899,401767,254796,872222,708049,119307,928652,709584,768994,691804,96914,177779,953345,525933,1033797,627510,888366,117874,892277,280071,718384,385490,680029,304746,446611,223688,703704,668503,617521,125147,595571,245787,129025,856673,963541,191457,463956,595753,558,176088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000829s ]