SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54116 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54116 [ RunTime:0.002624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130101,259185,477286,915578,102346,931570,522863,422857,979027,1005925,38327,586290,1013180,232144,559799,163347,609652,9744,422121,832166,9737,354389,848176,761886,519569,908035,354477,212319,804349,205685,399557,966991,591865,820464,633745,413299,709952,122214,11379,858317,786935,371664,967777,152786,532739,796794,958904,489058,549037,614202,320558,832173,166455,777182,596068,74730,251404,401909,528243,114309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]