SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406535 LIMIT 1 [ RunTime:0.000567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406535 [ RunTime:0.002950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586210,238074,955540,873401,132034,924725,1040573,81035,537560,790647,830523,382711,111926,867149,625783,371592,582924,730105,989925,125413,297558,75466,669870,1018022,711358,343685,600337,96872,830812,598536,549762,1048452,200568,349371,895308,48624,427722,971982,652519,757166,791673,630025,598817,752206,525355,286091,777233,526328,621391,902779,330623,867312,932973,133939,741859,376308,834691,714196,589621,78329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]