SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601028 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601028 [ RunTime:0.002487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305382,57235,39632,756159,827542,1032203,208954,610939,100544,67856,867178,488496,863348,993051,467522,184530,714665,1045894,670676,851325,836149,218424,86383,704475,793086,622323,831772,610249,260539,560404,518192,737818,522285,948967,323470,452041,721911,657093,246970,612442,190003,144370,268826,425460,707080,1028656,982227,964108,916900,718169,532582,343183,822218,341135,858632,609128,786857,989036,933663,1032091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001739s ]