SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299853 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299853 [ RunTime:0.002257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239380,554822,380736,809793,730412,757523,87627,648431,1014193,29202,814566,538120,483412,192341,872778,776099,623779,135525,844397,312978,398912,259974,205581,297318,688821,403200,176708,852060,452924,6085,459771,327281,516468,1024256,721764,610652,482324,668073,149346,545031,974436,387621,301542,450808,460146,925814,149137,639268,910313,217880,710940,625673,355465,537908,796898,264599,890909,1048660,106850,732029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]