SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035046 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035046 [ RunTime:0.001464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183168,795213,522486,524010,563161,256764,46526,271028,446426,1044676,25677,158923,121452,880469,237513,888429,713388,473634,211596,554500,920898,707057,844431,112758,525466,791875,817914,317063,180830,649486,579410,381765,2672,813440,295094,78467,46661,294657,334151,268129,701091,199833,823829,773824,510414,597456,9705,707756,651155,384831,523766,28877,250992,1047838,280267,907029,421432,1039064,7840,707936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]