SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245313 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245313 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772631,198648,292300,406569,903778,956197,895704,929975,383905,845556,988924,518005,276570,412017,986380,145894,240562,422261,431886,329033,741513,46205,192220,128462,41159,365974,264670,963651,1021816,184924,194789,199944,335352,486502,48995,231063,771273,970400,419013,511651,810426,165597,193812,483379,195029,533392,79061,741239,447062,12426,796767,354394,142632,981172,234967,610531,442770,240165,32149,354364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]