SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345313 LIMIT 1 [ RunTime:0.000275s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345313 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557784,378885,632986,393156,354698,917444,160057,788430,673649,330109,276381,131869,31438,591460,625515,1011912,712531,1035473,612754,324119,423259,626061,141165,15746,591631,757179,617479,322867,996199,29198,421722,739368,62732,533497,273586,260995,810432,693408,892774,847126,714181,226782,276315,867877,610570,83070,755674,884661,528409,930926,278789,199996,906216,351939,510696,466560,845446,379541,551448,780486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000915s ]