SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59650 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59650 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109579,883275,937188,779817,243311,706999,209552,730388,907859,648128,535580,536250,782676,530597,181989,71753,454402,476299,1014332,975522,661624,701830,62188,261762,233672,992958,572545,791066,362365,481598,455659,1034798,401631,7853,738433,14091,606811,225860,537546,425820,864614,853364,994815,207185,62169,279419,671415,67799,107341,607490,630111,68479,467008,849871,740741,2157,87117,229151,70833,732147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000903s ]