SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200486 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200486 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482746,400266,131653,631078,331142,148339,32593,944973,165787,77375,842200,95474,77395,912919,218165,67010,41036,440633,562340,735025,800869,533005,433601,624909,984134,939283,849366,672624,532818,662923,565656,268139,572039,648424,397081,126858,650865,752904,403227,808142,541522,536338,481563,263300,665656,332765,21032,137193,379308,792328,1022839,1013696,107169,980249,598465,766647,19236,679281,234585,467091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200486 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000789s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200486 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]