SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 748940 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 748940 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495002,1017627,534794,312362,95153,591893,823759,318608,396842,219797,305014,1009387,843580,567460,516874,146992,961580,757034,36081,392557,117045,912311,711256,483106,968706,48203,371560,77145,129650,490846,1023887,209597,556821,267409,320772,469732,45175,355669,603357,419636,383258,22828,79019,920944,541519,130298,301800,152855,266352,497593,187580,458467,699318,236421,976808,298683,1018679,753436,902330,918337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 748940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 748940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]