SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029222 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029222 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327147,20228,245073,877983,677351,31237,654078,938915,841618,970072,830574,722211,121307,63756,3186,855890,500965,350431,305285,736118,803145,323279,47332,443856,360193,261722,903201,488789,947677,863999,180339,280727,224439,683340,928711,833800,384824,865469,130138,861986,977489,440413,543434,228746,692240,691694,433241,487105,237122,169453,41696,400881,248432,952221,566625,976035,263717,121522,892505,1020594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]