SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382170 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382170 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529639,7094,121099,669838,977443,654767,330867,494579,94375,9,645697,1021064,649264,50372,571039,78646,371693,83632,457579,592866,251609,401088,623091,300988,265279,134342,935279,377843,705588,77945,630429,365875,375127,788834,819353,730015,127084,499669,385321,751742,119667,913798,355695,749656,795100,661206,117182,772599,874906,107529,441914,232289,401292,688484,64718,824923,758347,701984,875985,229994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]