SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267423 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267423 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684802,932191,638023,614808,63924,750814,257071,16964,1035306,384232,864409,957227,560948,295443,955160,473792,368418,485485,71982,503452,469988,93406,313887,681067,835940,280718,390499,78914,455843,211097,596697,730261,365422,180098,444864,442573,769714,836488,804408,633373,956310,591423,842216,366564,508597,77849,872310,1006948,995947,435283,555889,468516,887999,90617,618468,557245,826672,1032607,707470,74088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]