SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463448 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463448 [ RunTime:0.002547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958171,565577,712352,245770,337454,292063,362871,972731,400897,208439,215033,929973,974167,730459,852651,881323,6161,783998,412056,382093,774326,747316,40387,890758,821266,146524,235464,990764,921893,27117,441388,1020189,390239,40148,887448,158072,534830,607746,78252,883017,11701,8092,203358,830324,123532,765883,736258,828799,701939,985887,352277,906410,376439,695824,421133,378809,187085,610721,595392,952362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]