SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20132 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20132 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77936,988493,545561,874787,872107,14129,214844,504666,1959,357492,1031237,400168,649842,774567,358717,454729,534322,804463,981774,195866,904424,1009636,88299,1014474,463077,750131,813161,316830,851167,997381,890590,40357,152664,643569,224315,968897,785419,941678,865827,558971,345958,146032,581191,961761,230862,1010022,527826,216560,326976,717645,151212,865007,451657,304277,2277,813749,933219,690470,719901,377049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20132 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000803s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20132 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]