SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20313 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20313 [ RunTime:0.002877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258153,352119,52601,207986,521961,248352,731816,132521,545661,364622,546569,359443,730602,794459,869704,592420,939424,342063,286574,970068,640920,586471,19087,672299,558127,38797,14379,484808,536959,24947,62629,35115,186811,870447,509391,824926,926357,978953,510379,883506,346613,429265,979614,502751,757081,914796,30151,277575,253893,955383,152215,25648,363543,1034974,1012084,1014048,29600,865441,786963,817014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]