SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44700 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44700 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338103,334695,224259,969072,471349,22816,762280,954026,324314,388808,627803,155005,286963,916910,1043226,292900,212883,1009726,192221,317011,1035404,965017,433123,639022,332862,218886,408544,151892,148040,191999,44641,910640,143102,351470,524232,833796,534034,27884,459056,143841,552122,863237,542964,333094,896955,114504,170260,342960,886554,759270,540511,633317,155374,157541,913225,987650,918916,822955,370315,207203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]