SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197648 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197648 [ RunTime:0.002141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371118,1018604,694538,203736,194252,151400,1030967,738887,658658,800289,292097,258132,401562,830194,695207,355926,129662,951448,286404,724051,646829,448529,499353,811735,461843,552022,539292,118632,901082,258161,114271,114047,270783,484177,778504,114780,329109,534588,623792,926619,549490,512093,438676,644512,824229,321499,559786,349710,672462,962406,631444,120609,5134,223675,487000,924640,539384,667685,375974,914864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]