SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507516 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507516 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853028,183478,423624,190303,442526,496589,179784,290711,315408,973531,817912,706812,409733,850715,415489,229661,234592,331861,990789,1027995,657908,176268,308119,394477,28042,627032,438811,687323,847704,306671,336891,121112,218624,151033,713637,290183,552770,864480,248486,387461,220081,484763,557205,16925,187451,708186,882878,861478,90497,512990,373155,228455,879260,851111,679344,857211,135152,387786,458583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001080s ]