SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501031 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501031 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118122,589607,669781,978073,457196,910120,1041015,327882,523815,798668,176994,173641,488564,1011332,1030418,156846,70685,697542,517804,260787,988319,215122,1021382,988989,179701,21016,302669,827410,490306,944968,459328,377850,1035228,123774,226102,700691,107911,791935,181653,8070,394242,715710,22506,976315,1000602,415309,266107,67888,824017,1024879,913684,681882,189459,775075,344203,803147,406950,459102,819394,467041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001137s ]