SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335141 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335141 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242112,792420,46440,1574,930310,830663,1028010,973064,371289,25283,527011,605911,862451,144518,431247,870454,371730,195512,427363,954338,38150,17770,500250,285287,835094,595617,605940,60572,854719,19249,993513,998155,954192,605601,244977,270554,44863,429981,774580,948385,540153,23575,42473,634672,384166,791872,86323,372717,91418,911102,1027446,777931,776909,176389,854273,496361,555930,262321,436975,50147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]