SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001811s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391797 LIMIT 1 [ RunTime:0.000645s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391797 [ RunTime:0.002213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54386,902199,526299,777926,916189,958965,597759,99541,373072,814274,725632,243687,168252,969026,248753,947814,836554,15728,750712,787529,112541,579653,96916,33624,151276,143303,532269,914368,153543,1036725,114112,133093,761146,841087,486900,767739,100301,548788,869809,330729,1011780,451505,385873,744170,963528,7569,427750,312274,700272,70397,372284,381988,470902,584260,974490,261981,582816,446594,64799,61093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]