SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43289 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43289 [ RunTime:0.003696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814337,84456,749677,371287,1010821,941710,38875,594465,714641,65014,150853,579882,612919,120621,11448,532571,239018,725671,981561,1046596,279277,794532,431243,510076,322570,655857,780930,486017,733866,714523,993482,980674,505639,396548,745707,261036,294053,308524,440107,1040132,725273,383883,575466,757139,874570,107371,381952,580499,893579,146740,143687,114089,663461,1001453,1038737,698569,197697,366189,149343,124527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]