SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431514 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431514 [ RunTime:0.002122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80717,511958,290743,221071,71337,973701,784524,497115,66582,44653,293544,192173,958466,348717,806496,778170,140583,790988,595995,349830,363963,289400,765338,685160,364665,1037124,877240,65638,229349,897906,522832,884415,88600,268691,133697,37823,410823,921898,207052,123033,73301,860312,448340,886029,327025,608031,798371,90233,874777,229821,280026,668578,1025923,896647,155002,472262,10088,338138,163213,648796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]