SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341447 LIMIT 1 [ RunTime:0.001772s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341447 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512905,800027,296195,103080,1005014,531953,200706,881002,605842,234632,568900,852300,712035,623053,877645,614276,504779,858383,807732,516378,26104,774971,835828,870756,1006484,16569,992200,696637,141807,498344,501861,345618,611930,764255,622045,1019504,567845,461080,592032,1007168,1011356,310773,403944,772692,445692,385584,640529,586115,650163,547654,93503,393228,222438,751847,557545,662480,698207,154236,154025,145745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000779s ]