SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538098 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538098 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319259,642759,491160,327248,7944,207588,32449,516431,412428,394193,329756,638881,247905,544117,953944,263318,776296,199730,187941,671615,834402,700972,932880,1002337,542280,777498,470428,225696,696699,507317,609730,221361,602319,1045705,529288,485351,751436,619417,156464,700888,47971,807629,315629,567242,38456,454770,398813,517880,687713,628588,109747,501942,652310,575578,816971,669283,985198,691201,435451,40265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]