SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439021 LIMIT 1 [ RunTime:0.001463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439021 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411807,978827,625582,83388,702767,432740,178123,382114,164926,1047639,474042,646105,726176,528193,90602,1044564,562942,499560,1030619,482613,409868,140154,459353,821738,22232,168980,224772,256741,917186,562940,903451,462876,330299,898496,768182,594187,884337,962692,565565,172239,816810,507,298922,615663,452274,500424,1041019,637263,196965,439400,979286,700461,644836,494599,729029,791702,1048478,683220,992073,351425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001180s ]