SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043323 LIMIT 1 [ RunTime:0.000998s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043323 [ RunTime:0.002154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868789,532854,382873,777282,152350,1038861,646209,478078,108111,247187,559330,731581,732209,242685,972085,571228,847976,854329,131948,229153,747977,1021771,841526,391934,596749,1043035,682804,838163,558168,218783,969582,338277,751135,572162,393261,26505,657753,963247,417602,459403,200972,1031974,886957,136280,282216,831348,3610,697708,500336,47565,758428,322502,959216,56750,824907,667382,848491,288406,63569,342567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003140s ]