SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392416 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392416 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455929,768355,298882,585451,240347,565225,401595,425500,1044611,120640,80476,523626,492072,374218,889666,929919,428582,679434,989463,798638,973597,634436,663434,578589,21721,867861,810673,194428,728831,487481,347217,592265,789962,134843,526880,863829,141227,1011143,337900,1031982,439853,213038,856496,328770,405898,897261,464694,564158,581430,176076,443852,885835,889180,420101,355923,337690,956615,751222,393623,497107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]