SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039457 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039457 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672115,1025036,889169,953672,298061,154361,930823,447566,104803,459469,316441,103987,301954,91636,1048517,865906,33677,422782,702513,221394,471050,147671,15670,543492,728055,812046,955592,728006,644039,248069,347462,716752,56910,658684,593975,807564,757783,999426,698627,191903,437128,535669,819094,252567,990451,205026,1014554,797085,962561,377777,236608,834137,816459,995538,786467,492193,660238,553275,51603,108574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001200s ]