SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023452 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023452 [ RunTime:0.001906s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706506,789691,914809,171852,897602,37013,754359,337098,847895,235909,745313,67584,360203,597427,12962,56098,50363,917745,592830,181800,589253,942996,324967,950818,443796,496993,213114,996557,526140,481358,500342,515350,613079,1002149,217811,482668,729916,914591,923986,102572,812377,711029,363221,237591,623855,755412,923020,237645,210818,1002448,926842,890029,722258,461536,375819,1018726,332563,294424,885144,606712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]