SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004468s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671808 LIMIT 1 [ RunTime:0.001211s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671808 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813366,428953,8787,627677,48458,284242,170041,340868,123754,799866,951568,897287,54356,528332,141681,899721,160164,981162,97148,801673,365877,166026,47906,392113,942507,328243,503315,14613,832691,609140,808337,693716,457438,189013,798362,721724,673671,661742,422016,257782,254746,114227,595020,755879,394320,910121,616818,134438,798098,933842,727712,277524,427001,331752,742771,742330,775228,522015,133049,740213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]