SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599830 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599830 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715865,574657,774493,789852,748659,428911,776583,951593,1035562,169920,290926,289704,721626,41776,639511,517809,649092,995813,650649,987091,1006556,822315,362273,205338,162518,153413,248811,23729,1042114,462454,570776,399620,133350,843159,697247,1006940,1014987,97733,467355,498560,249571,196071,838386,14346,785745,560009,552093,577165,69814,99670,269068,24424,883988,240419,348716,88556,357303,449105,111726,168542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]