SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201598 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201598 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897536,1014152,618832,159872,482758,995523,168124,872695,236562,314082,469232,453848,192963,283458,722843,49157,324399,886413,529942,320547,290809,355257,860085,703253,1002166,555001,131055,536708,47045,1040862,440402,535567,469032,900723,991963,208826,613488,962878,688852,100495,963295,29241,439482,163511,821930,643925,385798,970694,461498,233585,211665,821373,626104,361544,893669,190172,831464,598170,440599,969606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]