SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448054 LIMIT 1 [ RunTime:0.001685s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448054 [ RunTime:0.006387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120871,691867,495249,573861,295119,9479,40722,342500,899595,61492,409396,674840,508938,882833,65032,770718,909682,997419,333953,852068,611603,253019,201411,25046,434863,96336,247594,472112,121047,117902,666690,801692,42840,957885,550598,978885,155939,143640,887572,1019517,420212,650804,21724,769325,699193,174082,375134,800869,461886,648477,265314,848787,454050,647814,225552,935459,159599,679688,71048,590503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]