SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541491 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541491 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53770,678685,951822,569983,379591,654124,739553,662525,410515,954951,842617,670602,1015467,955753,229614,474521,665174,553747,69208,832599,103177,832256,173435,75763,837264,701625,718994,921805,256983,721336,555583,946843,370921,10566,586126,939575,1026191,784314,57096,652861,813127,306678,528224,141235,802914,887642,307176,240518,424724,562947,221125,985209,722756,442876,949180,763533,414820,23999,577382,506833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]