SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003701s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511889 LIMIT 1 [ RunTime:0.001631s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511889 [ RunTime:0.003157s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770571,638608,766329,138391,138792,483813,327743,574573,69421,212153,166087,769200,328784,463686,455569,949249,126135,436597,540254,369263,630883,405707,115097,418603,19122,103850,919359,623676,241528,951853,827833,551831,1016829,152537,51322,1043446,514185,157123,545955,583291,466053,56903,124772,264514,944729,447048,150088,682206,982572,512497,204202,926287,422156,932040,350723,464186,1030226,1017579,747852,500274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511889 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511889 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]