SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488545 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488545 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455351,698192,672023,945956,773597,523352,871894,485509,701860,1000471,501098,828189,630472,334465,632417,222273,660936,835712,586015,956454,590041,456797,611514,112572,519029,1027233,450833,525623,225709,11903,1037949,840318,125803,541796,837958,335143,627026,106669,384827,626945,388613,293550,906079,481040,966016,174612,109767,359468,209012,41322,22282,37859,400204,184385,416055,585030,401513,107281,844032,742304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]