SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449314 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449314 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516856,174833,56519,217889,850352,541680,248648,296162,108069,11918,537528,81711,549628,847119,696481,791387,818623,634499,611766,741940,322764,323666,163790,1026511,27498,192788,990694,925215,843025,1009022,964437,538217,992881,258732,876354,328387,608135,637266,211300,966057,1037414,38580,132741,231685,569771,114163,911944,67791,489110,269321,171608,649992,639307,382610,348953,229743,407947,536747,240145,224769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]