SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000374 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000374 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512931,491333,266339,304841,920101,180925,353036,29486,574297,454780,1026310,96318,596416,1014629,128681,47967,819303,1020572,438416,142690,439590,169135,833676,713139,809701,157282,324385,840054,172268,278715,919856,853775,63088,1046782,283414,7637,1040079,113494,859207,458890,161141,31812,884040,940518,859513,741927,868767,790817,856747,104662,130655,69744,33061,1046575,1026363,814407,448781,700844,81255,358419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000374 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000374 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]