SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017223 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017223 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596736,598091,197129,195275,647984,867536,548108,681639,264434,1042072,419288,302544,882983,943724,729926,383000,373127,114246,204348,1014242,900603,840353,954163,43115,179015,371024,827933,1023565,1028991,16508,220236,104715,391731,470969,677218,813177,756456,83470,446325,1033583,615544,474128,36479,837659,559111,774240,851906,870939,308032,546895,416747,485909,186636,1036471,188781,472582,353765,387653,670435,252489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001154s ]