SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042024 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042024 [ RunTime:0.004643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932006,1011075,1023862,938488,682144,685935,30833,862993,45717,861035,175454,157036,386984,157763,850054,747346,392951,132306,96458,687711,434307,815513,734384,195831,272735,205050,364190,46925,150329,342975,690844,504836,711415,989157,133804,130453,299913,727726,37005,1014770,526004,1027167,447109,907165,466407,54022,986280,751798,121567,643262,369927,639863,273629,846770,259612,823979,157032,458270,187749,281866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]